CREATE TABLE [dbo].[TransactionRoleTransactionTypes]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[TransactionRoleId] [int] NULL,
[TransactionTypeId] [int] NULL,
[Status] [int] NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[TransactionRoleTransactionTypes] ADD
CONSTRAINT [FK_RoleTransactiontype_Role] FOREIGN KEY ([TransactionRoleId]) REFERENCES [dbo].[TransactionRoles] ([Id])
GO
ALTER TABLE [dbo].[TransactionRoleTransactiontypes] ADD CONSTRAINT [PK_RoleTransactiontype] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TransactionRoleTransactiontypes] ADD CONSTRAINT [FK_RoleTransactiontype_TransactionTypes] FOREIGN KEY ([TransactionTypeId]) REFERENCES [dbo].[TransactionTypes] ([Id])
GO
